﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="jobs.aspx.vb" Inherits="GLOBALDATABASE.WebForm4" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="job_id" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:BoundField DataField="job_id" HeaderText="job_id" InsertVisible="False" 
            ReadOnly="True" SortExpression="job_id" />
        <asp:BoundField DataField="job_desc" HeaderText="job_desc" 
            SortExpression="job_desc" />
        <asp:BoundField DataField="min_lvl" HeaderText="min_lvl" 
            SortExpression="min_lvl" />
        <asp:BoundField DataField="max_lvl" HeaderText="max_lvl" 
            SortExpression="max_lvl" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:pubsConnectionString4 %>" 
    DeleteCommand="DELETE FROM [jobs] WHERE [job_id] = @job_id" 
    InsertCommand="INSERT INTO [jobs] ([job_desc], [min_lvl], [max_lvl]) VALUES (@job_desc, @min_lvl, @max_lvl)" 
    SelectCommand="SELECT * FROM [jobs]" 
    UpdateCommand="UPDATE [jobs] SET [job_desc] = @job_desc, [min_lvl] = @min_lvl, [max_lvl] = @max_lvl WHERE [job_id] = @job_id">
    <DeleteParameters>
        <asp:Parameter Name="job_id" Type="Int16" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="job_desc" Type="String" />
        <asp:Parameter Name="min_lvl" Type="Byte" />
        <asp:Parameter Name="max_lvl" Type="Byte" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="job_desc" Type="String" />
        <asp:Parameter Name="min_lvl" Type="Byte" />
        <asp:Parameter Name="max_lvl" Type="Byte" />
        <asp:Parameter Name="job_id" Type="Int16" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>
